﻿USE [sms]
GO
/****** Object:  StoredProcedure [dbo].[cp_login]    Script Date: 01/13/2011 14:05:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[cp_login]
@CIL nvarchar(50) --输入参数，发件人
as
declare @UserID int
	--传入的名字.返回0为false
	if(len(@CIL) != 0)
		begin
			select * from [User] where CIL= @CIL and IsActive = 4
		end
	else
	   select * from [User] where UserID = -1
	